Error: #DIV/0! displays because divisor in formula is zero or blank.

Error:

#DIV/0!

Cause:

The formula contains a division operation in which the divisor is 0 (zero). The number 0 may be entered in the formula as a divisor, or it may be derived from a reference to a cell that contains nothing or a 0 (zero).

Solution:

Select the formula or the cell in which the divisor is either blank or 0 (zero). Make appropriate corrections to the values or eliminate the appropriate cells from the formula.